Hi, I have a Postgres database and I want to import its tables.
So, I created the DB, I synchronize it (with 3 database schema), and, WebRatio doesn't import some attributes or fields in my tables, casuallity, this attributes or fields are FOREIGN KEYS. I synchronized with button foreign key with option enable and disable. It is a bug?
In Metadata Database appear all fields!!!
//------------------PSQL----------------------------------//
Scripts in postgres:
CREATE TABLE metadatavalue
(
metadata_value_id integer NOT NULL DEFAULT nextval('metadatavalue_seq'::regclass),
item_id integer,
metadata_field_id integer,
text_value text,
text_lang character varying(24),
place integer,
authority character varying(100),
confidence integer DEFAULT (-1),
CONSTRAINT metadatavalue_pkey PRIMARY KEY (metadata_value_id ),
CONSTRAINT metadatavalue_item_id_fkey FOREIGN KEY (item_id)
REFERENCES item (item_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT metadatavalue_metadata_field_id_fkey FOREIGN KEY (metadata_field_id)
REFERENCES metadatafieldregistry (metadata_field_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
CREATE TABLE item
(
item_id integer NOT NULL,
submitter_id integer,
in_archive boolean,
withdrawn boolean,
last_modified timestamp with time zone,
owning_collection integer,
CONSTRAINT item_pkey PRIMARY KEY (item_id ),
CONSTRAINT item_submitter_id_fkey FOREIGN KEY (submitter_id)
REFERENCES eperson (eperson_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
CREATE TABLE metadatafieldregistry
(
metadata_field_id integer NOT NULL DEFAULT nextval('metadatafieldregistry_seq'::regclass),
metadata_schema_id integer NOT NULL,
element character varying(64),
qualifier character varying(64),
scope_note text,
CONSTRAINT metadatafieldregistry_pkey PRIMARY KEY (metadata_field_id ),
CONSTRAINT metadatafieldregistry_metadata_schema_id_fkey FOREIGN KEY (metadata_schema_id)
REFERENCES metadataschemaregistry (metadata_schema_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
Relationship:
metadatafieldregistry-----------------metadatavalue-----------------item
//----------END PSQL------------------------------------------//
//------------WebRatio----------------------------------------//
These tables and fields are what I see in WebRatio Domain Model
TABLE metadatavalue
(
metadata_value_id integer,
text_value text,
text_lang character varying(24),
place integer,
authority character varying(100),
confidence integer,
);
TABLE item
(
item_id integer,
in_archive boolean,
withdrawn boolean,
last_modified timestamp,
owning_collection integer,
);
TABLE metadatafieldregistry
(
metadata_field_id integer,
element character varying(64),
qualifier character varying(64),
scope_note text,
);
//----------------END WebRatio------------------------------------//
Thanks,
Jose